package com.bwie.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.bwie.pojo.Examination;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ExaminationMapper extends BaseMapper<Examination> {
    @Select("SELECT *,(examination.examination_nums - examination.examination_people) as remaining FROM examination")
    Page<Examination> listpage(Page<Examination> examinationPage);
}
